﻿

CREATE PROCEDURE [dbo].[proc_ConsumableList_Create]
(
	@ConsumableName NVARCHAR(100),
	@ConsumableAllMonth INT	,
	@UserId VARCHAR(20),
	@UserName NVARCHAR(20),
	@LrDate DATETIME
)
AS 
BEGIN
INSERT INTO [ConsumableList]
           ([ConsumableName]
           ,[ConsumableAllMonth]
           ,UserId,UserName,LrDate
           )
     VALUES
           (
           	@ConsumableName,
           @ConsumableAllMonth,@UserId,@UserName,@LrDate
           )

END

RETURN